﻿CREATE TABLE [dbo].[Store_CategoryMainProperty] (
    [Id]                INT            IDENTITY (1, 1) NOT NULL,
    [Name]              NVARCHAR (256) NULL,
    [Description]       TEXT           NULL,
    [Store_Category_Id] INT            NOT NULL,
    [Culture_Id]        INT            NOT NULL,
    CONSTRAINT [PK_Store_CategoryMainProperty] PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK_Store_CategoryMainProperty_Cultures] FOREIGN KEY ([Culture_Id]) REFERENCES [dbo].[Cultures] ([Id]),
    CONSTRAINT [FK_Store_CategoryMainProperty_Store_Category] FOREIGN KEY ([Store_Category_Id]) REFERENCES [dbo].[Store_Category] ([Id]) ON DELETE CASCADE ON UPDATE CASCADE
);

